/**
 *Copyright (c) 2024 watereyes
 * safetymanagement is licensed under Mulan PubL v2.
 * You can use this software according to the terms and conditions of the Mulan
 * PubL v2.
 * You may obtain a copy of Mulan PubL v2 at:
 *          http://license.coscl.org.cn/MulanPubL-2.0
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PubL v2 for more details.
 */
package com.koron.common.mapper;

import com.koron.common.bean.Corp;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface orgTreeMapper {

    @Select("<script>" +
            " select a.foreignkey from tbltree a left join tblorg b on a.type=b.treetype" +
            " where b.code=#{orgCode} and a.foreignkey in" +
            " <foreach collection='codeList' item='code' separator=',' open='(' close=')'> #{code} </foreach>" +
            " order by a.seq limit 1" +
            "</script>")
    String queryDeptCode(@Param("orgCode") String orgCode,@Param("codeList") List<String> codeList);

    @Select("select corp_code as code,corp_name as name from application_corp")
    List<Corp> getCorps();
}

